import openpyxl

def myFunc(myID):
	myList=[myID[x:y] for x,y in ((6,10),(10,12),(12,14))]
	myDate='-'.join(myList)
	return myDate

myBook=openpyxl.load_workbook('员工表.xlsx')
mySheet=myBook.active
myRows=list(mySheet.rows)[1:]
for myRow in myRows:
	myID=myRow[5].value
	myRow[6].value=myFunc(myID)
myBook.save('结果表-员工表.xlsx')